PEOPLE

"192.168.0.1:sipop"

PEOPLE

Descriptions

There is no desription for table PEOPLE

Fields

PK	FK	Name	Domain	Data type	Not null	Default	Description
		SURNAME		VARCHAR (50)
		FIRSTNAME		VARCHAR (50)
		SOUNDEXCODE		CHAR (4)

Triggers

There are no triggers for table PEOPLE

Indices

Index	Fields	Active	Unique	Order
PEOPLE_PRIMARYKEY	SURNAME, FIRSTNAME			Ascending
PEOPLE_SOUNDEX	SOUNDEXCODE			Ascending

References

There are no references for table PEOPLE

Referenced

There are no tables referenced by table PEOPLE

Definition


CREATE TABLE PEOPLE (
    SURNAME VARCHAR (50) CHARACTER SET NONE COLLATE NONE,
    FIRSTNAME VARCHAR (50) CHARACTER SET NONE COLLATE NONE,
    SOUNDEXCODE CHAR (4) CHARACTER SET NONE COLLATE NONE);

CREATE UNIQUE INDEX PEOPLE_PRIMARYKEY ON PEOPLE (SURNAME, FIRSTNAME);
CREATE INDEX PEOPLE_SOUNDEX ON PEOPLE (SOUNDEXCODE);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 15/05/2005 05:10 p.m.